
package com.excesys.exsecs.energy.mapper;

import com.excesys.exsecs.common.data.datascope.ExsecsBaseMapper;
import com.excesys.exsecs.energy.entity.PowerMonthFlow;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 能耗表(月) 从总表定时取数据 存入
 *
 * @author zhangtailong
 * @date 2023-12-26 11:01:46
 */
@Mapper
public interface PowerMonthFlowMapper extends ExsecsBaseMapper<PowerMonthFlow> {
    Float sumPowerList(@Param("timeValue") String timeValue);

    List<Map<String, Object>> powerAnalyse(@Param("timeValue") String timeValue,
                                           @Param("energyType") String energyType);

    List<Map<String, Object>> powerMonthAnalyse(@Param("startTime") String startTime,
                                                @Param("endTime") String endTime,
                                                @Param("energyType") String energyType);

    List<Map<String, Object>> powerGroupBranchingByDate(@Param("timeValue") String timeValue, @Param("branchName") String branchName);

    Float powerSumByWhere(@Param("timeValue") String timeValue);

    List<Map<String, Object>> powerGroupAreaByDate(@Param("timeValue") String timeValue, @Param("areaName") String areaName, @Param("order") String order);

	List<Map<String,Object>> getAirSourcePower(@Param("timeValue") String timeValue);

	List<Map<String,Object>> getAirConditionPower(@Param("timeValue") String timeValue);

	List<Map<String,Object>> getCarbonTrend(@Param("timeValue") String timeValue);
}
